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

49 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
solitude910505(None) 
solitudes10105011solitudes
solicitude1352872solicitude
altitude9166673altitude
amplitude1452793amplitude
aptitude11195963aptitude
attitude9196033attitude
bolide9515563boli__de
colatitude1352753colatitude
collude10337993col_lude
finitude1244173finitude
fortitude1344223fortitude
habitude14264153habitude
holytide1544973holytide
iolite63221983iolit__e
latitude9185513latitude
longitude1142823longitude
multitude1246143multitude
oolite63319603oolit__e
polite83625073polit__e
seminude1145673seminude
servitude1343083servitude
silicide1147833silicide
siliquae1743233siliquae
silique1645643siliqu_e
similitude1352213similitude
slide64725413s_li__de
slitted83513313s_litted
soilure736233so_ilure
solate64526073solat__e
solated83618023solated_
solicitudes1482883solicitudes
solid65025083soli__d_
solider82912453soli__der
solidi73813153soli__di
solids74116403soli__ds
solidus8338113solidu_s
soliquid1844303soliquid
soliquids1943523soliquids
solitaire943933solitaire
solitary1146503solitary
soliton7410233solit_on
solitons849593solitons
solstice1047223solstice
solute64016663sol__ute
somite84519373somit__e
sopite84917713sopit__e
sopited104211063sopited_
volitive1446893volitive

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 Filter1786911461620.406440125.6
2DLD Change Limit146162496.87621256.8
3Display Results49490.0163062.5
 (SQL Overall)178691497.29824484.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.