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 “flymao” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
flyman14326421flyman
flymen14387772flymen
flyway18134692flyway
alamo7418143alam_o
alma66333023al_ma_
almah106917253al_mah
almas76629773al_mas
bayamo1335603bayamo
bayman133712703bayman
cayman133613213cayman
climax1735653climax
cyma116715843_cyma_
cymae126713013_cymae
cymar125711263_cymar
cymas126417883_cymas
etyma1036583etyma_
firman112211343firman
flab96628353fl__ab
flag87427083fl__ag
flagman13186173flagman
flak116026173fl__ak
flam96333293fl__am
flambe13489153flambe
flame105124443flam_e
flamed124618973flamed
flamen115215993flamen
flamer114919123flamer
flames114723693flames
flams105125013flam_s
flamy135217473flam_y
flan76134183fl__an
flap96128703fl__ap
flat77147823fl__at
flaw106326643fl__aw
flax147325633fl__ax
flay106332803fl__ay
flea75628493fl_ea_
fleam106017283fl_eam
fleams115011943fleams
fleas86423663fl_eas
flimsy14345563flimsy
float85928573fl_oat
flora85317103flora_
florae94713883florae
floral94313813floral
floras94715693floras
flota85315643flota_
flotas94013003flotas
flume106021173flum_e
flumed124915263flumed
flumes115119733flumes
flummox2141413flummox
flump124614723flum_p
flumps135112503flumps
fly97124953fly___
flyaway1943163flyaway
flyblow1841903flyblow
flyboat1546003flyboat
flyboy17113913flyboy
flyby1676003fly_by
flybys1792773flybys
flyer114916253fly_er
flyers125712803flyers
flying134612153flying
flyleaf1642583flyleaf
flyoff1444023flyoff
flypast1583753flypast
flysch1732893flysch
flyte115713943fly_te
flyted13378773flyted
flytes123911563flytes
flytrap1543253flytrap
flyways19133853flyways
foeman11311233foeman
formal113215203formal
format113021353format
frypan1434543frypan
fulmar1137253fulmar
glycan1234903glycan
lama66635293_lama_
lamas75532793_lamas
layman113511303layman
leman75622603_leman
lima65734133_lima_
liman75921603_liman
limas75627633_limas
limbo95614813_limbo
limo65529733_lim_o
llama799893llama_
llamas888973llamas
luma65527523_luma_
lumas75622913_lumas
lymph1547043_lymph
skyman1535313skyman
tryma1037223tryma_
ulama7711473ulama_
ulamas8910453ulamas
ulema7109713ulema_
ulemas888963ulemas

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit112716995.84319290.8
3Display Results99990.0303300.0
 (SQL Overall)178691996.01329717.4
 
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.