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

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

88 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
fliest9471842(None) 
flies85630711flies_
sliest66621941sliest
alist56136782ali_st
blest76431722bl_est
bluest84016482bluest
client8316342client
driest74722752driest
eeliest73516472eeliest
eldest72912682eldest
elmiest9310742elmiest
fainest10417702fainest
fairest10412292fairest
falsest10310012falsest
feist86230072fei_st
fellest10313752fellest
fest74949442f__est
fewest12311662fewest
feyest12311402feyest
fiesta938122f_iesta
files85441272files_
filet85540162file_t
filets94718952filets
filmiest1338552filmiest
finest94321732finest
first86226122f_irst
fist76248422f_i_st
flakiest153210542flakiest
flamiest133111972flamiest
flawiest14298572flawiest
flaxiest18298182flaxiest
flees85828752flees_
fleet85932332fl_eet
fleets96915062fleets
flesh115013742fl_esh
flics105418362flics_
flied96519432flie_d
flier86023402flie_r
fliers94417192fliers
flight134014812flight
flimsy14345562flimsy
flint87333502fli_nt
flints95617452flints
flippest1535172flippest
flips105117742flips_
flirs85518932flirs_
flirt87424752fli_rt
flirts95411482flirts
flit76539272fli__t
flites95122442flites_
flits85625222flits_
floes85528142floes_
fluent9313932fluent
flues84626922flues_
flukiest15248062flukiest
flutiest112610882flutiest
foist85730972foi_st
folkiest15319502folkiest
forest94926742forest
foxiest174310492foxiest
foziest194110942foziest
freest95318282freest
fries85535602fries_
fullest10313342fullest
fumiest12312192fumiest
funest94316862funest
gluiest839772gluiest
holiest104319622holiest
iciest82914742iciest
iffiest1337952iffiest
illest63615722illest
lest46956322_l_est
lies46454192_lies_
likest104914382_likest
list47055342_li_st
livest95315732_livest
oiliest72817682oiliest
oldest72114092oldest
paliest93021602paliest
plies74526512plies_
priest84125422priest
ruliest72816422ruliest
shiest95821522shiest
slyest93811362slyest
ugliest8410142ugliest
vilest9416842vilest
wiliest103416592wiliest
wriest94419712wriest

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit82551882.48333246.5
3Display Results88880.0631396.8
 (SQL Overall)178691882.67266875.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.