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

70 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
zoolaters184498(None) 
zoolater1746091zoolater_
idolaters1045712idolaters
violaters1245962violaters
zoolatry2042862zoolat_ry
bloaters103311023blo_aters
boaters93419243_bo_aters
bolsters103712453_bolsters
bolters94017803_bol_ters
boosters104013443boo_sters
cholates132414763cholate_s
coaters93525793_co_aters
collates103019143collate_s
collators11410343collators
colters93522443_col_ters
combaters1538113combaters
coolers93522493cool__ers
cooters94525723coo__ters
coulters103614313coul_ters
deflaters13298703deflaters
desolaters1146043desolaters
dilaters92513063_dilaters
doomsters1236173doomsters
elaters74420193__elaters
floaters112711513flo_aters
folates103218453_folate_s
footers104618333foo__ters
gloaters9288863glo_aters
holsters113211943_holsters
hoopsters1445683hoopsters
hooters104520463hoo__ters
idolater936863idolater_
idolators1046283idolators
inflaters1247543inflaters
isolates8613513isolate_s
isolators947513isolators
jolters143711993_jol_ters
locaters102710073_locaters
looters74419163loo__ters
molters93816973_mol_ters
monolayers1543923monolayers
mooters93818623moo__ters
moulters103510783moul_ters
oaters65029793__o_aters
oblates91913243_oblate_s
oolites72817843_oolite_s
ozonates1745963ozonate_s
platers93924093__platers
pollsters1137173pollsters
polluters1135033polluters
poofters1336923poo_fters
poolers94217423pool__ers
poulters103911053poul_ters
relaters83218153_relaters
roosters83514663roo_sters
rooters74522933roo__ters
slaters73123733__slaters
solacers10268893_solacers
solates73523853_solate_s
toolers74416503tool__ers
toolmakers1643013toolmakers
tooters73818773too__ters
violater1137253violater_
violates11311193violate_s
violators1246583violators
woolers104214023wool__ers
zeolites1738383zeolite_s
zoolatries1943673zoolatries
zooplankters2761093zooplankters
zosters163015413z_o_sters

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.1531167915.0
2DLD Change Limit148641707.53319732.0
3Display Results70700.0302333.3
 (SQL Overall)178691707.71623158.5
 
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.