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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
sieges7381683(None) 
lieges74113441lieges
siege66718441siege_
sieged85212711sieged
sieves93216001sieves
singes74326851singes
beiges91014412beiges
besieges1146002besieges
bilges94915632bilges
binges93923122binges
dienes75719902dienes
dieses75218692dieses
dinges83825422dinges
dirges84915102dirges
fidges114114392fidges
hinges105121032hinges
leges64427292_leges
liege65314432liege_
midges103516482midges
nieces84112712nieces
nieves94311292nieves
pieces104217272pieces
reges65628792_reges
ridges85817012ridges
sages65339062s_ages
sarges75128592sarges
scenes84520352scenes
sedges83817812sedges
sees45361052s_e_es
segos64919482s_egos
segs54933882s_eg_s
segues7412072s_egues
seines65029902seines
seises64026712seises
seizes154317532seizes
semes75731582s_emes
seres55448892s_eres
serges74225972serges
sexes126126222s_exes
sices75637272si_ces
sides65838362si_des
sidles74721152sidles
siemens938412siemens
sieurs659042sieurs
sieve84918842sieve_
sieved104611442sieved
sighs95416742si_ghs
signs65516322si_gns
sikes96236082si_kes
silages82514442silages
silexes1438652silexes
sines55954822si_nes
singe65731132singe_
singed85422292singed
singer74227312singer
singers83824702singers
singles83520432singles
sings65532702sing_s
sipes76036952si_pes
sirees64624582sirees
sires55945372si_res
sises55233832si_ses
sisses64520602sisses
sites56045432si_tes
sixes124526362si_xes
sixtes133612402sixtes
sizes146727762si_zes
skees95023122ske_es
skegs105011232skeg_s
skenes104616632skenes
sledges94511572sledges
slieves10378962slieves
smidges11448192smidges
spiegel1034552spiegel
spiegels1133872spiegels
stages75629492stages
steles63725662steles
steres63929532steres
suedes73918112suedes
surges73924592surges
swages104417072swages
swedes102711892swedes
swinges113413422swinges
tinges74722332tinges
veges94118872_veges

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.346516448.0
2DLD Change Limit82551852.59331836.1
3Display Results85850.0302833.3
 (SQL Overall)178691852.96960185.6
 
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.