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

93 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
irrupt84699(None) 
irrupts943731irrupts
abrupt1039942abrupt
corrupt1149102corrupt
disrupt1048632disrupt
erupt74220062_erupt
irrupted1143122irrupted
arrant6623253arrant
arrest63722633arrest
bruit76126723_bruit
brunt75728753_brunt
brut66537963_bru_t
chirrup14123833chirrup_
chirrups15133043chirrups
chirrupy18132023chirrupy
circuit1148833circuit
cirrus8349173cirru_s
corrupts1244983corrupts
crept95125893_crept
croup95616783croup_
croupe105114433croupe
croups104312553croups
croupy13458733croupy
cruet74831843_cruet
crust75827663_crust
crypt123715233_crypt
disrupts1145293disrupts
dript86923873_dript
dropt86924433_dropt
drupe85012993_drupe
enrapt8313013enrapt
errant6618733errant
eruct74022353_eruct
erupts8348903_erupts
fruit85122223_fruit
gript85126173_gript
group85413923group_
groups94210513groups
grout65330423grou_t
grunt65523543_grunt
inapt73522693i_napt
incept102712753incept
incorrupt1353083incorrupt
incrust949203incrust
incult82414773incult
induct93212743induct
indult73614033indult
inept73622153i_nept
input7314653inpu_t
inrun52911373inru_n
inruns6359513inruns
inrush936513inrush
insult62813673insult
interrupt1147243interrupt
intrust7311493intrust
intuit6314083intuit
irreal657833irreal
irrupting1243553irrupting
irruption1143783irruption
irruptive1443433irruptive
kraut95221403krau_t
larrup835713larrup_
larrups934733larrups
prompt12313013prompt
rapt67245313__rapt
roup66627693_roup_
roupet84218343_roupet
roups75118903_roups
roupy106112713_roupy
roust55532063_roust
rout46153283_rou_t
runt46647993__runt
rust45544913__rust
rut35560523__ru_t
script105717903script
sirup74014913sirup_
sirups83710533sirups
sirupy11377053sirupy
stirrup943003stirrup_
stirrups1042603stirrups
stript85222193stript
strunt64918913strunt
strut56030733stru_t
syrup103010963syrup_
syrups11277953syrups
syrupy14285823syrupy
thruput1243863thruput
thrust91911893thrust
trapt76433393_trapt
troupe84812433troupe
trout57332573trou_t
trust55426853_trust
wrapt105123183_wrapt

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 Filter1786911127160.673265514.1
2DLD Change Limit112716938.18613769.4
3Display Results93930.0332818.2
 (SQL Overall)178691938.89220095.7
 
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.