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

109 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
inspect113846(None) 
insect83916581ins_ect
inspects1255861inspects
aspect10612822_aspect
infect113413442in_fect
inflect1249222inflect
inject153210232in_ject
insects93710842ins_ects
insert64325252ins_ert
inset54430862ins_e_t
inspected1445402inspected
inspector1344752inspector
inswept1245732inswept
reinspect1344302reinspect
respect11412032respect
suspect1158512suspect
unspent92610892unspent
anapest9311563anapest
aspects1146743_aspects
bisect10312873bis_ect
disject17268673disject
dissect103614133dissect
expect1758903_expect
exsect1558503exs_ect
impact122310453i_mpact
inanest72115363inanest
inapt73522693inap__t
incent83320723in_cent
incept102712763in_cept
incest82918743in_cest
indent73021243in_dent
indict93115573in_dict
indirect1147523indirect
induct93212743in_duct
indwelt1146513indwelt
inept73622153in__ept
inert53234373in__ert
inexact1647413inexact
inexpert1746083inexpert
infarct1249013infarct
infects12279713in_fects
infest93315433in_fest
inflects1336193inflects
inflict1248623inflict
infract12610003infract
ingest73119003in_gest
injects16257453in_jects
inkiest113415043inkiest
inkjet1737453inkje_t
inkpot1237813inkp_ot
inlet53732403in_le_t
input7314653in_p_ut
inquest1638603inquest
insanest8410343insanest
inseam8329993ins_eam
insectan1045393ins_ectan
inserts74013993ins_erts
insets64016133ins_ets
insheath14114423insheath
insight1137913insight
insist6314513ins_ist
insolent81311553insolent
inspan837513insp_an
inspans937803inspans
inspecting1546223inspecting
inspection1446663inspection
inspective1746413inspective
inspectors1444933inspectors
insphere1355973insphere
inspire938253inspire
inspirit1046283inspirit
instant7815353instant
instead836203instead
instep838193inste_p
insteps936573insteps
instinct1048723instinct
instruct1047543instruct
insult62813673ins_ult
intact8314663in_tact
intent63122773in_tent
intreat7416303intreat
introspect1474383introspect
invent93316363in_vent
invert94120083in_vert
invest93014843in_vest
islet54527553i_sle_t
misspelt1247273misspelt
misspent1259173misspent
onset54730173ons_e_t
prospect1447893prospect
reinspects1443033reinspects
resect84424703res_ect
respects1247703respects
respelt9312143respelt
sect67443623__s_ect
spec85821973__spec_
speck135115653__speck
specs96916673__specs
spelt75430193__spelt
spent75532833__spent
suspects1254863suspects
unpent83117373un_pent
unseat64221023uns_eat
unsent63820963uns_ent
unset54532433uns_e_t
unspeak1344793unspeak
unspilt938853unspilt
unsplit956563unsplit
unswept1246013unswept

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271096.46620728.0
3Display Results1091090.0631730.2
 (SQL Overall)1786911096.96525655.6
 
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.