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

46 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
soliciting134681(None) 
eliciting1237772_eliciting
solecising1345752solecising
solecizing2246472solecizing
solicitant1254242solicitant
sonicating1348312sonicating
colocating1548623colocating
delimiting1445843delimiting
domiciling1643663domiciling
foliating1339253foli_ating
lichting14268513__lichting
limiting1138813__limiting
logicising1443723logicising
logicizing2344813logicizing
policing13311673polic__ing
salinizing2047433salinizing
salivating1447433salivating
selecting12310533selec_ting
silicifying2062513silicifying
sinicizing2245753sinicizing
slicing103514643s_lic__ing
slicking153712593s_lic_king
slighting1436373s_lighting
slitting93012583s_li_tting
solacing11310133solac__ing
solarising1147053solarising
solarizing2048283solarizing
solating9315593sol__ating
solicit9315743solicit___
solicitants1352173solicitants
solicited1247973solicit_ed
solicitor1144403solicit_or
solicitors1244213solicitors
solicitous1244173solicitous
solicits10311023solicit__s
solicitude1352873solicitude
solidifying1952793solidifying
solidities1149503solidities
solvating1336443sol_vating
sopiting11310763so__piting
spiriting1238413s_piriting
splicing1338963splic__ing
splinting1238193spli_nting
splitting1236563spli_tting
spoliating1366963spoli_ating
suiciding1345453s_uiciding

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603465.89023871.5
3Display Results46460.0162875.0
 (SQL Overall)178691466.31228309.7
 
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.