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

230 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
sphinges1426748(None) 
sphinxes20334401sphinxes
springes114014031springes
hinges105121032__hinges
rehinges1248402rehinges
shines95028912s_hin_es
shingles123111112s_hingles
singes74326852s__inges
sphenes123013162sphen_es
sphingid1543742sphingid
sphingids1642932sphingids
sphynxes23292422sphynxes
spinages11289292sp_inages
spines85132032sp_in_es
splines94718892splin_es
sponges10311042sp_onges
springe103913982springe_
springed123911322springed
springer113311752springer
springers12309982springers
springs104415922spring_s
swinges113413422s_winges
syringes122810212syringes
unhinges12266722unhinges
whinges143610632_whinges
anhingas12104333anhingas
aphides134711203aphi_des
astringes1038343astringes
binges93923123__binges
changes134517583_changes
chines115029173_chin_es
cringes103215503_cringes
dinges83825423__dinges
fringes113514103_fringes
henges104516463__henges
hinge95323453__hinge_
hinged114618923__hinged
hinger104723333__hinger
hingers113420213__hingers
impinges13297423impinges
meninges1137433meninges
ophites12310103ophi_tes
opines84820703op_in_es
phages125213513_ph_ages
phizes20389133_phi_zes
phones114121213_phon_es
phonies123717513_phonies
pines76048863_p_in_es
pinged104321383_p_inged
pinger94324093_p_inger
pingers104020743_p_ingers
pingoes105116523_p_ingoes
pingos95317673_p_ingos
pings85830883_p_ing_s
plunges104011623_plunges
pointes93216753_pointes
princes113015153_princes
rehinge1148503rehinge_
rehinged1336853rehinged
sabines94318483sabin_es
salines74029413salin_es
salpinges1244523salpinges
saplings11269803sapling_s
savines104417633savin_es
savings114412953saving_s
sayings113610833saying_s
seeings84411293seeing_s
seines65029903s_ein_es
serines74229543serin_es
seringas9339003seringas
sewings11369173sewing_s
shies86136553s_hi__es
shikses14116573s_hikses
shindies122610503s_hindies
shindys14314133s_hindys
shine85533093s_hin_e_
shined104620783s_hin_ed
shiner93820873s_hin_er
shiners104015943s_hiners
shingle117711283s_hingle
shingled13358323s_hingled
shingler12268633s_hingler
shinglers13246443s_hinglers
shingly143210813s_hingly
shinier104113143s_hinier
shiniest113212503s_hiniest
shinned114310923s_hinned
shinney13368303s_hinney
shinneys14275103s_hinneys
shinnies113010923s_hinnies
shins85131043s_hin__s
shires95225573s_hi_res
shives124921413s_hi_ves
shrines104618693shrin_es
sidings94011463siding_s
sieges73816833s__ieges
sines55954823s__in_es
singe65731133s__inge_
singed85422293s__inged
singer74227313s__inger
singers83824703s__ingers
singles83520433s__ingles
sings65532703s__ing_s
siphonages1642993siphonages
sizings17378013sizing_s
skiings12295733skiing_s
slinger83413833s_linger
slingers93712683s_lingers
slings74618013s_ling_s
smidges11448193s_midges
sophies12314623sophi__es
sorings83817253soring_s
sozines16611263sozin_es
spacings13287043spacing_s
spaeings11276253spaeing_s
spangles1138893sp_angles
sparges104016343sp_arges
speises93813933spei_ses
speisses10245693speisses
spences113413923sp_ences
spenses92913573sp_enses
sphene113412403sphen_e_
spheres123114353sph_eres
sphincter1642233sphincter
sphincters1742073sphincters
sphinx1866203sphin__x
spices104326033sp_i_ces
spiegel1034553sp_iegel
spiegels1133873sp_iegels
spies76037623sp_i__es
spikes124520713sp_i_kes
spiles84227913sp_i_les
spilings11308813spiling_s
spinage10289653sp_inage_
spinals93911863sp_inals
spindles112710353sp_indles
spine76534423sp_in_e_
spined95423943sp_in_ed
spinel85317333sp_in_el
spinels94512443sp_inels
spinet85629753sp_in_et
spinets94714813sp_inets
spinier93715163sp_inier
spiniest102813233sp_iniest
spinless10238703sp_inless
spinner93912263sp_inner
spinners103810863sp_inners
spinney12438923sp_inney
spinneys13335553sp_inneys
spinnies103210543spinnies
spinors939423sp_inors
spinose937943sp_inose
spinous9310443sp_inous
spins75327983sp_in__s
spintos939133sp_intos
spinules10249333sp_inules
spires84628113sp_i_res
spites84127333sp_i_tes
spitzes1849183sp_itzes
splices113914383spli_ces
spline86020533splin_e_
splined105013113splin_ed
splinted11369253splinted
splinter10329703splinter
splinters11277923splinters
splints94511743splin_ts
splodges1234153splodges
splurges1145163splurges
spoilages12184713spoilages
sponge939663sp_onge_
sponged1137953sp_onged
sponger1038523sp_onger
spongers1137603sp_ongers
spoonies101911753spoonies
sprangs104610053sprang_s
sprigged13316223sprigged
sprigger12366503sprigger
spriggers13325493spriggers
sprigs94814773spri_g_s
spring94526013spring__
springal1145973springal
springals1245373springals
springier1236023springier
springiest13156683springiest
springlet1257523springlet
springlets1344033springlets
springy13359663spring_y
sprinkles1534933sprinkles
sprinted113411163sprinted
sprinter103810813sprinter
sprinters11329373sprinters
sprints94113773sprin_ts
sprites94220333spri_tes
spritzes1946943spritzes
spuing94313363spuing__
spurges104111653sp_urges
spying123913253spying__
stinger84314683s_tinger
stingers94012743s_tingers
stingos8459453s_tingos
stings76220183s_ting_s
stranges94516763stranges
stringed102911873stringed
stringer93812943stringer
stringers104210653stringers
strings84617133string_s
supines94216383supin_es
swinge105614383s_winge_
swinged123810793s_winged
swinger113812563s_winger
swingers123710423s_wingers
swingles12319543s_wingles
swings104714453s_wing_s
syringas12285953syringas
syringe11349473syringe_
syringed13377583syringed
syrinxes18294423syrinxes
things104914303_thing_s
tinges74722343__tinges
twinges11409453_twinges
unhinge11237283unhinge_
unhinged13257473unhinged
uppings12257123upping_s
vahines133410523vahin_es
wahines133111173wahin_es
whines125120103_whin_es
whinge134311543_whinge_
whinged15409153_whinged
whinger1410810913_whinger
whingers15358723_whingers

Search took 9 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.516346300.4
2DLD Change Limit1461622307.50019488.3
3Display Results2302300.0932473.1
 (SQL Overall)1786912308.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.