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

72 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
semplice144701(None) 
complice1639332complice
emplace1338262_emplace
hemplike1936122hemplike
resplice1237252resplice
semple103212752sempl__e
simplices1546042simplices
splice104915102s__plice
surplice1246202surplice
complices1739253complices
compline14313553compline
empire1039323_emp_ire
emplaced1536053_emplaced
emplaces1438413_emplaces
emplane11410013_emplane
employe1476363_employe
emprise11310723_emprise
emprize2038843_emprize
gemlike14206813gem_like
hemline12311073hem_line
hempie132410563hemp_i_e
malice104818483__malice
pemoline12310273pemoline
pumplike1834373pumplike
replace113214283re_place
replica1137943re_plica
reprice113212833re_price
respliced1445543respliced
resplices1336623resplices
samphire1545833samphire
sample104215013sampl__e
sampling13510643sampling
seallike12108323seallike
seamlike14127183seamlike
seapiece1244373seapiece
seaplane1049163seaplane
seedlike1335993seedlike
sematic111716873sematic_
semblance1544403semblance
sememic1336503sememic_
semolina1047493semolina
sempre102710093semp__re
sepaline10311343sepaline
sepic94617053se_p_ic_
septic102713193se_ptic_
septics112810433se_ptics
septime1138803se_ptime
serflike1536273serflike
service1239093se_rvice
setline7313923se_tline
simple104315173simpl__e
simplicia1563243simplicia
simplify1843553simplify
simplism14216243simplism
simplist12249683simplist
sleeplike1543463sleeplike
slice74925823s___lice
soaplike1436903soaplike
someplace1544033someplace
souplike1436333souplike
spice95528813s__p_ice
spliced124310593s__pliced
splicer114710523s__plicer
splices113914383s__plices
spline86020533s__pline
stemlike1436723stem_like
steplike1436733steplike
surpliced1444153surpliced
surplices1346043surplices
template1238433template
temple102811333templ__e
tumpline1237113tumpline

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.420425454.8
2DLD Change Limit146162727.39319770.3
3Display Results72720.0302400.0
 (SQL Overall)178691727.84322783.5
 
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.