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

92 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
solated8361802(None) 
isolated9410521isolated
slated75028311s_lated
solaced102911061solaced
solate64526071solate_
solates73523851solates
solvated12237441solvated
ablated102513442ablated
alated75625152_alated
belated103520012belated
bloated104513432bloated
boated94221972bo_ated
bolted94617802bol_ted
borated104116362borated
coated94927042co_ated
collated113615062collated
delated93722872delated
desolated1139652desolated
dilated93115822dilated
doated84118182do_ated
donated93513862donated
elated74725822_elated
floated113312702floated
folate93320392folate_
folates103218452folates
foliated1249912foliated
gelated93615642gelated
gloated93511532gloated
insolated1039712insolated
iodated9310022iodated
isolate7313922isolate_
isolates8613512isolates
jolted143510632jol_ted
lated65240672__lated
lobated102610942lobated
located103114182located
moated94819002mo_ated
molted94217472mol_ted
notated82713662notated
orated74221502_orated
plated95225772_plated
related83327572related
rotated82715292rotated
salted74121202sal_ted
saluted84511712saluted
sated66238532s__ated
seated75131062s_eated
sedated93714352sedated
silted74020012sil_ted
skated114414882s_kated
slaked114318272s_laked
slanted83514742s_lanted
slate55438282s_late_
slater64429182s_later
slates64934062s_lates
slatey95417062s_latey
slatted84015182s_latted
slaved104017042s_laved
slayed104716222s_layed
slotted84613882slotted
soaked114717592so_aked
soaped95817972so_aped
soared74324292so_ared
sofabed1334332sofabed
solace83415822solace_
solacer93011102solacer
solaces93116132solaces
soland75115042sola_nd
solatia7312252solatia
soled65835172sol__ed
soloed74515742sol_oed
solute64016662solute_
solutes73515262solutes
solvate102710212solvate_
solvates11249672solvates
solved105312932sol_ved
sooted73922592so_oted
sopited104211062sopited
sorted74523712so_rted
sotted74121402so_tted
splatted11356742splatted
splayed13357812splayed
spoliated1246912spoliated
stated75427832s_tated
sublated11311502sublated
sulcated11310372sulcated
sulfated1238832sulfated
sweated113411542sweated
togated94410662togated
violated1237882violated
voluted11297942voluted
zonated173310532zonated

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit107671923.37331921.4
3Display Results92920.0462000.0
 (SQL Overall)178691923.79547085.9
 
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.