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

114 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
spiraeas1028623(None) 
spiraea9407981spiraea_
spireas94412511spir_eas
piranas9912602_piranas
pirayas1277482_pirayas
spirals93212512spira_ls
spirants1088282spirants
spirea84015632spir_ea_
spirems11499562spir_ems
spires84628112spir_e_s
spirulas10207202spirulas
aspirants1145233aspirants
aspirata1054993aspirata_
aspiratae1143353aspiratae
aspirates1139613aspirates
aspirers1066493aspir_ers
aspires9612043aspir_e_s
picaras11311283_picaras
pinatas93711503_pinatas
piraguas1144453_piraguas
pirana8713263_pirana_
piranhas13135873_piranhas
pirates93020333_pirates
piraya1167713_piraya_
pitayas1286263_pitayas
psoraleas1172863psoraleas
puranas9712643_puranas
shires95225573shir_e_s
shirkers15319583shirkers
sifakas1443333s_ifakas
sirees64624583s_ir_ees
sirens65318153s_ir_ens
sires55945373s_ir_e_s
sirras63814863s_ir_ras
sirrees73410573s_irrees
skirrets12244013skirrets
skirters12337243skirters
smirkers14316353smirkers
soirees72411643soir_ees
spaes76029973sp__ae_s
sparers94519613spar_ers
spares84834553spar_e_s
spargers11389733spargers
sparges104016343sparge_s
sparkers144111313sparkers
spearers103711143spearers
spelaean1043213spelaean
spicae104313703spicae__
spicas104715823spi__cas
spicers113815553spi_cers
spices104326033spi_ce_s
spiders103914413spi_ders
spiegels1133873spiegels
spielers10319653spielers
spiels85317953spi__els
spiers84421743spi__ers
spies76037623spi__e_s
spikers135311993spi_kers
spikes124520713spi_ke_s
spiles84227913spi_le_s
spillers103311703spillers
spinages11289293spinages
spinals93911863spina_ls
spinels94512443spi_nels
spines85132033spi_ne_s
spinets94714813spi_nets
spinless10238703spinless
spinners103810863spinners
spinneys13335553spinneys
spiracle1255803spiracle
spiracles1345663spiracles
spiral83715343spir__al
spiraled1137733spiraled
spirally1348023spirally
spirant9814293spira_nt
spire75828693spir_e__
spired94921863spir_e_d
spirem104214163spir_e_m
spireme11478363spir_eme
spiremes12397623spiremes
spirier93214073spirie_r
spiriest102513463spiriest
spirits94112623spir_its
spirted103913073spirte_d
spirts85317133spir__ts
spirula9257703spirula_
spirulae10216573spirulae
spitals93011593spita_ls
spites84127333spi_te_s
spitters104113383spitters
spitzes1849183spitze_s
spores84726613spor_e_s
sporters103714063sporters
sprags95715823sp_ra_gs
sprains93013593sp_rains
sprangs104610053sp_rangs
sprats85819933sp_ra_ts
sprawls12176373sp_rawls
sprayers13367053sp_rayers
sprays115913643sp_ra_ys
spread9312533sp_r_ead
spreads1039763sp_reads
sprees85620643sp_r_ees
sprites94220333sprite_s
sprues84515763sp_rue_s
spurges104111653spurge_s
spurners10288493spurners
spurrers10338463spurrers
spurreys13364603spurreys
spurters103311703spurters
stirpes95011293stirpe_s
stirrers8266943stirrers
stratas73013583s_tratas
subareas1038623subareas

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.436409841.7
2DLD Change Limit1461621146.50022486.5
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.98225593.1
 
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.