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 “stolider” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

168 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
stolider93660(None) 
solider82912451s_olider
scolder103210332scol_der
slider73918362s__lider
smolder10327752smol_der
solder73921342s_ol_der
soldier82812152s_oldier
staider83912612st_aider
stolid74213172stolid__
stolidest1046112stolidest
stolidly1243832stolidly
stonier72013792stoni_er
strider84315722st_rider
stupider1133912stupider
styliser11185522styliser
stylizer20185442stylizer
atelier7311623ateli_er
atomiser10268153atomiser
atomizer19298533atomizer
avoider1155813avo_ider
bolder94820933_bol_der
bolide9515563_bolide_
bolides10515073_bolides
broider103912973bro_ider
colder95121833_col_der
collider113410413collider
folder104317543_fol_der
glider84614263__glider
golder84417603_gol_der
holder104619653_hol_der
holier94921623_holi_er
idoliser945043idoliser
idolizer1845663idolizer
molder93819273_mol_der
moldier103110033_moldier
motlier92010583motli_er
older65121173__ol_der
pistolier1146383pistoli_er
polder94019253_pol_der
policer113112683_policer
politer92417073_politer
provider1436703provider
sallier73320423salli_er
scalier94316913scali_er
scolded11358853scol_ded
scolders11288993scol_ders
scolices1238733scolices
scowder13286853sco_wder
shalier103116423shali_er
shoalier1137063shoali_er
shoddier1334203shoddier
shoulder1234753shoulder
showier1339093showi_er
sillier74017583silli_er
slicer84117603s__licer
slide64725413s__lide_
sliders83515223s__liders
slides73922183s__lides
slier54827243s__li_er
sliver94116593s__liver
smokier1356703smoki_er
smolders11287193smol_ders
smoulder1133443smoulder
snider74413913s__nider
snowier1038783snowi_er
solacer93011103s_olacer
solander948123s_olander
solders83517773s_ol_ders
soldiers9277773s_oldiers
soldiery12254613s_oldiery
solid65025073s_olid__
solidary1245103s_olidary
solidest9310383s_olidest
solidi73813153s_olid_i
solidly1137353s_olidly
solids74116403s_olid_s
solidus8338113s_olidus
solver94016703s_ol_ver
sonder73623523s_o_nder
sootier73916603sooti_er
sounder83315383s_ounder
spider94516803s__pider
splicer114710523s_plicer
spoiler93310683spo_iler
squalider1943843squalider
stagier83513443stagi_er
stainer73614923st_ainer
staler64025823stal__er
stalker113912253stal_ker
stalkier1257073stalkier
stander84316163st_ander
steadier937313steadier
steelier839183steeli_er
stiller73414283stil_ler
stillier868813stillier
stiver93915733st__iver
stocker133713083sto_cker
stockier14217253stockier
stodgier1034223stodgier
stogie7311313stogi_e_
stogies8413693stogi_es
stoker104417623sto__ker
stole54928813stol__e_
stoled74521593stol__ed
stolen64315063stol__en
stoles63927673stol__es
stolidity1344683stolidity
stollen747573stol_len
stomodea1143623stomodea
stomper114111223sto_mper
stoner65823203sto__ner
stooker113811733sto_oker
stoolie739713stooli_e_
stoolies8311083stooli_es
stooper93813183sto_oper
stoper84320093sto__per
stopover1344063stopover
stopper113012593sto_pper
storer64721673sto__rer
storied8515163stori_ed
stories7324273stori_es
stormier1036103stormier
stounded10276213stounded
stouter74012053sto_uter
stover94115643sto__ver
strainer8512213strainer
straiter8311773straiter
strander97112053strander
stride75420963st_ride_
striders94412123st_riders
strides84520393st_rides
stridor8467383st_ridor
striker113714173st_riker
striper94514783st_riper
striver104315203st_river
stroller848163strol_ler
studier82510053studi_er
studlier935473studli_er
stuiver10447083st_uiver
sturdier9216953sturdier
styler94013303styl__er
stylise10208953stylise_
stylised12215893stylised
stylisers12204233stylisers
stylises11188943stylises
stylite10219613stylite_
stylites11168693stylites
stylize19177453stylize_
stylized21175863stylized
stylizers21194323stylizers
stylizes20207113stylizes
sublimer1237603sublimer
subsider1138243subsider
surlier72915443surli_er
timider1037093_timider
toiler63918283_to_iler
tolidin839243_tolidin
toller63819443_tol_ler
toluide835263_toluide_
toluides935543_toluides
tonier65520713_toni_er
topsider1144503_topsider
torrider936163_torrider
utilidor941923utilidor
utiliser855243utiliser
utilizer1756193utilizer
voider103611553_vo_ider
woolier103612353wooli_er

Search took 10 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.1561145455.1
2DLD Change Limit1461621689.31315694.4
3Display Results1681680.0602800.0
 (SQL Overall)1786911689.52918752.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.