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
maim8583147(None) 
aim57858211_aim
maid75537631maid
mail65543431mail
maims96321781maims
main65345501main
mair66133761mair
malm85129971malm
maxim165216001maxim
mim76048411m_im
ai211288392_ai_
aid49269072_aid
ail37171042_ail
aims67738182_aims
ain37579092_ain
air38058392_air
ais39083572_ais
ait38093902_ait
am411875562_a_m
amain74922882amain
ami56646802ami_
amia66836892amia
amid77036332amid
amie66339842amie
amin66042242amin
amir65129742amir
amis66445312amis
arm58449622_arm
bail65042802bail
bait66556002bait
balm85534202balm
bam78560142ba_m
barm86739602barm
brim85629372brim
caid77837532caid
cain65643912cain
calm85032362calm
cam78058982ca_m
claim95616912claim
dais57040702dais
dam67457042da_m
dim68146492_dim
email74715092email
fail74840242fail
fain75840562fain
fair76332522fair
farm95934532farm
gain56042162gain
gait56150192gait
gam67060062ga_m
gaum75726422gaum
glim76026352glim
grim76929422grim
haem95730982haem
haik115526982haik
hail74839062hail
hair76330142hair
hakim14311822hakim
halm95834972halm
ham86363282ha_m
harm95637792harm
him86247652_him
imam81718322ima_m
imaum9139632imaum
jail115529092jail
jam126942522ja_m
kaif116933922kaif
kail85131492kail
kain85334292kain
kami105823642kami
laic65931562laic
laid56439142laid
lain46146282lain
lair45934152lair
lam57666712la_m
ma410060652ma__
maar66025052maar
mabe85733342mabe
mac78053922ma_c
mace87345782mace
mach116134472mach
mack125733642mack
macs86742502macs
mad68958702ma_d
madam10316222madam
made75440232made
mads76845362mads
mae57659102ma_e
maes66948392maes
mafia104418032mafia
mafic125615462mafic
mag67956472ma_g
mage75739122mage
magi76329522magi
magic105818652magic
magma104513572magma
mags75444522mags
maids86327132maids
maihem1366212maihem
maile75232212maile
maill74420782maill
mails76037772mails
maimed114812662maimed
maimer104514592maimer
mains75635092mains
mairs76228292mairs
maist75535672maist
maize164618552maize
make105537882make
mako105622352mako
male66052292male
malic94525652malic
mall64639362mall
malms95021552malms
malmy124816342malmy
malt66254802malt
mama86231582mama
mamie95826002mamie
mamma86317912mamma
mammy115215162mammy
man57465852ma_n
mana65341942mana
mane65052012mane
mania75634142mania
manic94629432manic
mano66536792mano
mans66354532mans
many95731842many
map77255112ma_p
maps86141042maps
mar57965942ma_r
mara67444562mara
marc87034622marc
mare64759322mare
maria75032882maria
mark105138052mark
marl66341612marl
mars66261862mars
mart66865972mart
mas58175812ma_s
masa65034712masa
mash96039392mash
mask105227352mask
mass66044932mass
mast65959952mast
mat58083932ma_t
mate65154212mate
math95437442math
matin75132852matin
mats65460282mats
matt65752652matt
maud75325392maud
maul64830712maul
maun65727202maun
maut65448442maut
mavie104722562mavie
mavin105722952mavin
mavis105622722mavis
maw87050092ma_w
mawn94424132mawn
maws96437132maws
max129045442ma_x
maxi137023552maxi
maxima17568632maxima
maxims17399672maxims
maxis145721562maxis
may88757622ma_y
maya95824582maya
mayo96524292mayo
mays96940022mays
maze155434972maze
mazy186419692mazy
mem77943472m_em
mi48249042m_i_
miasm91211092miasm
mib76946102m_ib
mic77647632m_ic
mid67354452m_id
mig65646072m_ig
mil55752102m_il
mime85736392m_ime
minim97321592minim
mir57046762m_ir
mis58162612m_is
misaim10311852misaim
mix126138172m_ix
mm67826812m__m
moil65534082moil
mom78853162m_om
momi87524482momi
mum76643612m_um
mumm75718862mumm
naif76839012naif
nail45838652nail
nam55953392na_m
nim57142952_nim
oxim131114042oxim
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
palm85331362palm
pam77858392pa_m
prim85132202prim
qaid146023842qaid
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rain46251732rain
rais45252622rais
ram56867272ra_m
rami66034092rami
rim56052272_rim
said55742112said
sail45447162sail
sain45551292sain
shim95827842shim
sim56553132_sim
skim105322492skim
slim66631952slim
smarm95517602smarm
swim96221392swim
tail45443652tail
tain45548072tain
tam58663422ta_m
trim65329512trim
umami939882umami
vail75432552vail
vain75233002vain
vair75624142vair
vim87437022_vim
waif105836742waif
wail75238822wail
wain75840192wain
wair75830052wair
wait75553692wait
warm95935672warm
whim126220522whim
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.1231452772.4
2DLD Change Limit298722411.59318752.0
3Display Results2412410.0803012.5
 (SQL Overall)1786912411.79699493.9
 
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.