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

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

109 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
spiels8531795(None) 
shiels95418921shiels
speels85116391speels
speils84116221speils
spiel74623911spiel_
spiers84421741spiers
spies76037621spie_s
spiles84227911spiles
spills84717461spills
spinels94512441spinels
appels104312792appels
ariels65119372ariels
chiels115115932chiels
espials937092espials
espies83716802espie_s
oriels64914622oriels
peels75226422_peels
piers75926332_piers
pies66949602_pie_s
piles74742612_piles
pills74130972_pills
pixels15478532_pixels
riels55121332_riels
sails55738102sai_ls
samiels939762samiels
sapiens9310172sapiens
seels55632822s_eels
seidels838392seidels
sels46345982s__els
shiel811023772shiel_
shield106212972shield
shields11538042shields
shiers94921752shiers
shies86136552shie_s
shills94519612shills
sials54227242s_ials
sills55135992s_ills
sipes76036952sipe_s
skiers104713702skiers
skies95026832skie_s
skills104313922skills
skirls10449822skirls
smiles84522292smiles
snivels10336902snivels
soils55327982soi_ls
sorels63921162sorels
spaes76029972spae_s
spails84817822spails
spales84728102spales
spalls84217342spalls
spaniels1045962spaniels
specs96916672sp_ecs
speeds94316052speeds
speel74420762speel_
speers85019952speers
speil75618642speil_
speirs85013232speirs
speiss84311642speiss
spell75020302sp_ell
spells84617682spells
spelt75430192sp_elt
spelts84614642sp_elts
spews105015922sp_ews
spicas104715822spicas
spicers113815552spicers
spices104326032spices
spicks144814992spicks
spics94123242spi_cs
spiders103914412spiders
spied85427712spie_d
spiegels1133872spiegels
spieled104811882spieled
spieler93111232spieler
spielers10319652spielers
spier75728032spie_r
spiffs14328472spiffs
spikers135311992spikers
spikes124520712spikes
spiks114117472spi_ks
spile75230082spi_le
spiled94621992spiled
spill74821162spi_ll
spilt75532222spi_lt
spinals93911862spinals
spinel85317332spinel_
spines85132032spines
spinets94714812spinets
spins75327982spi_ns
spirals93212512spirals
spireas94412512spireas
spirems11499562spirems
spires84628112spires
spirts85317132spirts
spitals93011592spitals
spites84127332spites
spits74429552spi_ts
spivs105114242spi_vs
spoils84614532spoils
spools85115912spools
sprees85620642sprees
spues75025382spue_s
steels64117982steels
sties55132982stie_s
stiles64328772stiles
stills64118572stills
stipels9418952stipels
swills94213362swills
swirls94010132swirls
swivels13396772swivels

Search took 3 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 Filter178691825510.420425454.8
2DLD Change Limit825511092.29635954.3
3Display Results1091090.0333303.0
 (SQL Overall)1786911092.74965002.2
 
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.