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

86 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
stinted8291419(None) 
sainted84114241sainted
stilted83511471stilted
stinter73614511stinter
stunted83010401stunted
tinted74419531_tinted
dinted84419842_dinted
fainted114211722fainted
feinted11379622feinted
flinted114411892flinted
glinted9399372glinted
hinted104318322_hinted
jointed15378502jointed
linted74021822_linted
minted94220582_minted
painted104214632painted
pointed103813982pointed
printed104016372printed
retinted94414362retinted
sained75424242sain_ed
satiated9311602satiated
scanted104114392scanted
scented102811882scented
seined74023062sein_ed
shifted14359972shifted
shined104620782shin_ed
shinned114310912shinned
shitted114212042shitted
shunted11339772shunted
sifted104313672s_ifted
silted74020012s_ilted
singed85422292s_inged
sinned73818412s_inned
sinter63625922s_inter
sited65130742s_i_ted
skinked11339012skinked
skinned12387292skinned
skirted12388612skirted
skited114313472ski_ted
slanted83514742slanted
slinked123011382slinked
slitted83513312slitted
spined95423942spin_ed
spirted103913072spirted
spited94820442spi_ted
spitted103912702spitted
splinted11369252splinted
sprinted113411162sprinted
squinted1847052squinted
stained84215342stain_ed
staned74824642stan_ed
stanged94113842stanged
started84217322started
stated75427832st_ated
stetted82610402stetted
sticked144114632sticked
stied65723032sti__ed
stiffed14359582stiffed
stifled113511092stifled
stilled83314782stilled
stimied10310622stimied
stinger84314682stinger
stinker113313312stinker
stint57037662stint__
stinters83312752stinters
stints65119762stint_s
stiped94517072sti_ped
stirred8359692stirred
stoned75923142ston_ed
stotted83511412stotted
striated93414152striated
stringed102911872stringed
strunted957242strunted
stunned8358892stunned
suited74019422sui_ted
swinged123810792swinged
swinked15349032swinked
tainted83512422tainted
tented74221002_tented
tilted74616862_tilted
tincted1037272_tincted
tined65434532_tin_ed
tinged84220802_tinged
tinned74317532_tinned
tinter63923642_tinter
unstinted1038562unstinted

Search took 4 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 Filter1786911076710.1431249587.4
2DLD Change Limit107671863.54630364.1
3Display Results86860.0631365.1
 (SQL Overall)178691863.75247625.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.