Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “ogams” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ogams8411268(None) 
gams76648881_gams
ogam75120031ogam_
oghams1245851oghams
agama85815572agama
agamas97413442agamas
agars66120642agars
agas55938842aga_s
agmas85919872agmas
bams87044452_bams
beams95328172beams
blams95023852blams
bogans95714812bogans
cams87047282_cams
chams126028502chams
clams95127672clams
crams96229152crams
dams77444372_dams
dogmas105011242dogmas
drams86025832drams
egads74610922egads
exams14199082exams
flams105125012flams
foams105017952foams
forams115115912forams
gabs76740422_gabs
gads67843382_gads
gaes56348032_gaes
gags66441062_gags
gals57946502_gals
gam67060062_gam_
gama77035512_gama
gamas85431352_gamas
gamb96331842_gamb
gambs105721122_gambs
game76644322_game
games86238552_games
gamp98833212_gamp
gamps105323712_gamps
gamy105427532_gamy
gaps76042972_gaps
gars55750742_gars
gas48870252_ga_s
gats56753442_gats
gaums86217072_gaums
gays87338022_gays
gems75329112_gems
glams85822932glams
goads77022852goads
goals65521292goals
goas55239942goa_s
goats65527302goats
gorms85619592gorms
grams85327312grams
gums75030942_gums
gyms107514592_gyms
hams96446132_hams
hogans105914312hogans
imams91511112imams
jams135231072_jams
jorams154810532jorams
lams66552262_lams
loams75619862loams
logans76319062logans
logjams1743582logjams
oafs76425262o_afs
oaks86527902o_aks
oars46846032o_ars
oats46554212o_ats
obas65730932oba_s
ocas66729632oca_s
odahs95610082odahs
odas57230262oda_s
ofays11488922ofays
ogees65119142ogees
ogham1138252ogham_
ogles65223182ogles
ogres65818632ogres
ohms95514032o_hms
okas85225392oka_s
okays12609442okays
oms56337512o__ms
oogamy1235632oogamy
opahs105411982opahs
opals75718352opals
orals55826482orals
organs7912912organs
orgasm966302orgasm
orgasms1054292orgasms
ovals85413392ovals
oxims14107642oxims
pams85641762_pams
prams96125512prams
rams65950772_rams
reams75729622reams
roams74919612roams
scams94423972scams
seams75731662seams
shams105829412shams
slams74927902slams
spams94922192spams
tams67247932_tams
teams75726512teams
togas67823002toga_s
trams75327672trams
whams135515642whams
yams95330732_yams
yogas96615602yoga_s

Search took 4 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.1731032896.0
2DLD Change Limit538001083.47015504.3
3Display Results1081080.0601800.0
 (SQL Overall)1786911083.70348255.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.