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 “solates” 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
solates7352385(None) 
folates103218451folates
isolates8613511isolates
slates64934061s_lates
solaces93116131solaces
solate64526071solate_
solated83618021solated
solutes73515261solutes
solvates11249671solvates
ablates92416902ablates
alates64833972_alates
bolases93315002bolases
boletes9316062boletes
borates94823012borates
cholates132414762cholates
collates103019142collates
comates114123642comates
delates83526282delates
desolates10311792desolates
dilates83220662dilates
donates83217222donates
elates65032362_elates
folate93320392folate_
foliates11412752foliates
gelates83219592gelates
insolates9311272insolates
iodates8312902iodates
iolites73819482iolites
isolate7313922isolate_
isolated9410522isolated
locates93218812locates
malates93522612malates
notates72817482notates
oblates91913242oblates
oleates7417832_oleates
oolites72817842oolites
orates64328612_orates
palates93624942palates
plates85432242_plates
relates73731432relates
rotates72819772rotates
salutes73716252salutes
sates54949322s__ates
savates10312952savates
sedates83418042sedates
senates73322612senates
silages82514442silages
silanes72517162silanes
skates104219402s_kates
slakes104021882s_lakes
slate55438282s_late_
slated75028312s_lated
slater64429182s_later
slaters73123732s_laters
slatey95417062s_latey
slats55436902s_lat_s
slaves95023022s_laves
soaves94218672so_aves
socages101012052socages
soilages9189672soilages
solace83415822solace_
solaced102911062solaced
solacer93011102solacer
solacers10268892solacers
solands84412342solands
solanos74412852solanos
solans64122492sola_ns
solatia7312252solatia
soles55547922sol__es
solute64016662solute_
solvate102710212solvate_
solvated12237442solvated
solves95018222sol_ves
somites94219122somites
sonatas7510292sonatas
sopites93817172sopites
sorbates10311102sorbates
sorites73825242sorites
soulmates1147072soulmates
spates85028172s_pates
splakes1349672splakes
splats84817302splat_s
spoliates1138542spoliates
states64337082s_tates
stomates10313342stomates
sublates10315002sublates
sulfates11310792sulfates
tolanes74216312tolanes
toluates8138902toluates
violates11311192violates
voltes94915582vol_tes
volutes102710982volutes

Search took 6 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.373479064.3
2DLD Change Limit107671925.37620028.1
3Display Results92920.0631460.3
 (SQL Overall)178691925.81230745.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.