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

81 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
figeaters134575(None) 
figeater1236951figeater_
digesters11257882digesters
fidgeters1443622fidge_ters
fighters15269402fig_hters
firewaters1644322firewaters
anteaters939343anteaters
beaters94925043__beaters
begetters12135043begetters
bilgewaters1771653bilgewaters
bimesters1336343bimesters
bleaters103412323_bleaters
cheaters133613513_cheaters
ciguatera1241873ciguatera
ciguateras1351233ciguateras
defeaters13289103defeaters
diesters92513603di_esters
dieters83216433di_e_ters
digester10258433digester_
digestors11257273digestors
dilaters92513063di_laters
dimeters11411093dime_ters
diverters13227873diverters
eaters65535953___eaters
eggbeaters1451523eggbeaters
fagoters1234863fag_oters
fearers104815273f__earers
feasters11511563f__easters
feater95224053f__eater_
feathers143513243f__eathers
festers104121393f__esters
fetters103517903f__etters
fibsters13126413fi_bsters
fidgeter1343783fidge_ter_
fielders12156773fi_elders
fighter143010773fig_hter_
figurers12254873fig_urers
filiates11412663filiate_s
filisters1237003filisters
filters103816553fi__lters
fingerers13136303finge_rers
firewater1545213firewater_
fitters104517753fi__tters
fixates1737393fi_xate_s
floaters112711513f_loaters
fomenters1437853fomenters
foresters12312533foresters
forgetters1444163forgetters
fraters103517213f__raters
fretters113410303f_retters
frigates12310933frig_ate_s
gaters74728643__g_aters
getters84216103__getters
graters85419743__graters
heaters104225223__heaters
ideates8313733_ideate_s
igniters9126233_igniters
kiesters123310153ki_esters
ligates82318383lig_ate_s
lighters123111393lig_hters
limewaters1543523limewaters
migrates111112853migrate_s
migrators1247543migrators
misenters1139533misenters
negaters9349783neg_aters
pleaters103613793_pleaters
reheaters122010273reheaters
repeaters112811993repeaters
righters122610713rig_hters
rimesters1137483rimesters
riveters11228163rive_ters
seaters74028943__seaters
sighters122510603sig_hters
signalers1044583signalers
sweaters113811063_sweaters
theaters114211903_theaters
tidewaters1443463tidewaters
treaters83615843_treaters
vignetters1442453vignetters
violaters1245963violaters
wigmakers1943383wigmakers

Search took 8 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 Filter1786911486410.1701051123.5
2DLD Change Limit148641817.01621186.0
3Display Results81810.0302700.0
 (SQL Overall)178691817.21624763.2
 
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.