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

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

94 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
skirrets1224401(None) 
skirret11278171skirret_
sirrees73410572s_irrees
skillets12226822skillets
skippets16284562skippets
skirred12347082skirre_d
skirrs10448192skirr__s
skirters12337242skirters
skirts104111502ski_r_ts
stirrers8266942stirrers
aigrets82810533_aigrets
barrets94917103_barrets
chirres123812253chirre_s
ferrets103111393_ferrets
garrets84413623_garrets
hairnets1195633hairnets
kirmess13234313_kirmess
kismets13306883_kismets
scarlets10178573scarlets
scirrhus1342003scirrhus
secrets9311773s_ecrets
sherbets1335213sherbets
shires95225573shi_re_s
shirkers15319583shirkers
shirred113710503shirre_d
shirrs94413173shirr__s
shirts94918343shi_r_ts
signets83311503s_ignets
sippets113310183s_ippets
sirees64624583s_i_rees
sirens65318153s_i_rens
sires55945373s_i_re_s
sirrahs10377303s_irrahs
sirras63814863s_irr_as
sirree64017343s_irre_e
skeets104513253sk__eets
skerries12168673skerries
skidders1454823skidders
skiers104713703ski__ers
skies95026833ski__e_s
skijorers2041973skijorers
skilless12246763skilless
skillet113512153skillet_
skimmers16296463skimmers
skinkers11298183skinkers
skinless12216973skinless
skinners12347293skinners
skippers16318203skippers
skippet15288463skippet_
skirled12348183skirle_d
skirls10449823ski_r_ls
skirr94810543skirr___
skirring13297143skirring
skirt95624663ski_r_t_
skirted12388613skirte_d
skirter11338483skirte_r
skirtless13254423skirtless
skites104418043ski_te_s
skits94721863ski___ts
skitters12349553skitters
skivers14409703ski_vers
skives134113943ski_ve_s
skorts104211303sk_or_ts
smirkers14316353smirkers
sniglets9276813sniglets
snippets12225623snippets
soirees72411643soi_rees
solerets839693solerets
sorbets93012513s_orbets
sorrels7310723s_orrels
spinets94714813spi_nets
spiraeas10286233spiraeas
spirants1088283spirants
spireas94412513spi_reas
spirems11499563spi_rems
spires84628113spi_re_s
spiriest102513453spiriest
spirits94112623spi_rits
spirts85317133spi_r_ts
spurrers10338463spurrers
spurreys13364603spurreys
squirrels18333423squirrels
starets73515923s_tarets
starlets81610083starlets
sterlets8169273sterlets
stirpes95011293stirpe_s
stirred8359703stirre_d
stirrer7338233stirre_r
stirrups1042603stirrups
streets73312613s_treets
surreys10489443s_urreys
swivets13436963swi_vets
terrets72913583_terrets
turrets73010673_turrets

Search took 7 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.406440125.6
2DLD Change Limit146162946.26623326.2
3Display Results94940.0303133.3
 (SQL Overall)178691946.70226662.3
 
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.