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 “maim” 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.

241 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
maim8583149(None) 
aim57858211_aim
maid75537661maid
mail65543451mail
maims96321791maims
main65345521main
mair66133781mair
malm85129981malm
maxim165216001maxim
mim76048421m_im
ai211288392_ai_
aid49269082_aid
ail37171042_ail
aims67738182_aims
ain37579092_ain
air38058392_air
ais39083572_ais
ait38093902_ait
am411875562_a_m
amain74922912amain
ami56646812ami_
amia66836902amia
amid77036352amid
amie66339852amie
amin66042252amin
amir65129752amir
amis66445322amis
arm58449622_arm
bail65042802bail
bait66556002bait
balm85534202balm
bam78560142ba_m
barm86739602barm
brim85629372brim
caid77837532caid
cain65643912cain
calm85032362calm
cam78058982ca_m
claim95616912claim
dais57040702dais
dam67457042da_m
dim68146492_dim
email74715102email
fail74840242fail
fain75840562fain
fair76332522fair
farm95934532farm
gain56042162gain
gait56150192gait
gam67060062ga_m
gaum75726422gaum
glim76026352glim
grim76929422grim
haem95730982haem
haik115526982haik
hail74839062hail
hair76330142hair
hakim14311832hakim
halm95834972halm
ham86363282ha_m
harm95637792harm
him86247662_him
imam81718332ima_m
imaum9139642imaum
jail115529092jail
jam126942522ja_m
kaif116933932kaif
kail85131492kail
kain85334292kain
kami105823642kami
laic65931562laic
laid56439142laid
lain46146282lain
lair45934152lair
lam57666712la_m
ma410060662ma__
maar66025062maar
mabe85733362mabe
mac78053932ma_c
mace87345792mace
mach116134482mach
mack125733652mack
macs86742512macs
mad68958712ma_d
madam10316222madam
made75440242made
mads76845372mads
mae57659112ma_e
maes66948402maes
mafia104418032mafia
mafic125615462mafic
mag67956482ma_g
mage75739132mage
magi76329532magi
magic105818662magic
magma104513572magma
mags75444532mags
maids86327142maids
maihem1366212maihem
maile75232222maile
maill74420792maill
mails76037782mails
maimed114812662maimed
maimer104514592maimer
mains75635112mains
mairs76228302mairs
maist75535682maist
maize164618562maize
make105537892make
mako105622362mako
male66052302male
malic94525662malic
mall64639372mall
malms95021552malms
malmy124816342malmy
malt66254812malt
mama86231592mama
mamie95826002mamie
mamma86317912mamma
mammy115215162mammy
man57465872ma_n
mana65341962mana
mane65052032mane
mania75634152mania
manic94629442manic
mano66536812mano
mans66354552mans
many95731862many
map77255122ma_p
maps86141052maps
mar57965952ma_r
mara67444572mara
marc87034632marc
mare64759332mare
maria75032882maria
mark105138062mark
marl66341622marl
mars66261872mars
mart66865982mart
mas58175822ma_s
masa65034722masa
mash96039402mash
mask105227362mask
mass66044942mass
mast65959962mast
mat58083942ma_t
mate65154222mate
math95437452math
matin75132852matin
mats65460292mats
matt65752662matt
maud75325402maud
maul64830722maul
maun65727212maun
maut65448452maut
mavie104722562mavie
mavin105722952mavin
mavis105622722mavis
maw87050102ma_w
mawn94424142mawn
maws96437142maws
max129045452ma_x
maxi137023562maxi
maxima17568632maxima
maxims17399672maxims
maxis145721562maxis
may88757632ma_y
maya95824592maya
mayo96524302mayo
mays96940032mays
maze155434982maze
mazy186419702mazy
mem77943472m_em
mi48249052m_i_
miasm91211092miasm
mib76946122m_ib
mic77647642m_ic
mid67354472m_id
mig65646082m_ig
mil55752112m_il
mime85736402m_ime
minim97321602minim
mir57046772m_ir
mis58162622m_is
misaim10311852misaim
mix126138182m_ix
mm67826812m__m
moil65534092moil
mom78853162m_om
momi87524482momi
mum76643612m_um
mumm75718862mumm
naif76839022naif
nail45838652nail
nam55953392na_m
nim57142952_nim
oxim131114052oxim
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
palm85331362palm
pam77858392pa_m
prim85132202prim
qaid146023842qaid
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rain46251732rain
rais45252622rais
ram56867272ra_m
rami66034092rami
rim56052272_rim
said55742112said
sail45447162sail
sain45551292sain
shim95827862shim
sim56553142_sim
skim105322512skim
slim66631962slim
smarm95517602smarm
swim96221402swim
tail45443652tail
tain45548072tain
tam58663422ta_m
trim65329522trim
umami939882umami
vail75432552vail
vain75233002vain
vair75624142vair
vim87437022_vim
waif105836752waif
wail75238822wail
wain75840202wain
wair75830052wair
wait75553692wait
warm95935672warm
whim126220532whim
yam87448992ya_m

Search took 2 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 Filter178691298720.263679433.5
2DLD Change Limit298722410.78338150.7
3Display Results2412410.0604016.7
 (SQL Overall)1786912411.106161565.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.