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

151 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
inspans93780(None) 
inspan837511inspan_
insane6314882ins_ane
inseams9307902inseams
instals7611712instals
instant7815342instant
instants8910152instants
instars7411132instars
spans74528732__spans
wingspans1542392wingspans
anurans73810553anurans
aspens85013353_aspens
bedpans1237173bedpans
desmans1039003desmans
dishpans14115833dishpans
dustpans1143233dustpans
ensigns836353ensigns
firepans1347153firepans
frypans1544053frypans
gossans836783gossans
impawns1433323i_mpawns
inane52820343in__ane
inanes62519803in__anes
incant82418503in_cant
incants92012803in_cants
indicans1147663indicans
infant92315133in_fant
infants102210773in_fants
ingrains948983ingrains
inions64417003in_ions
inkpots1335173inkpots
inkstand1343803inkstand
inkstands1443193inkstands
inland7310313in_land
inlands838783in_lands
inlays9389873in_lays
inns46920933in___ns
inputs837703in_puts
inroads837043inroads
inruns6359513in_runs
insaner7310443ins_aner
insanest8410343ins_anest
inscape1138013inscape
inscapes1237813inscapes
inseam8329993insea_m
insects93710843insects
inserts74013993inserts
insets64016133ins_ets
insides8512653insides
insigne837673insigne
insists739083insists
insnare748243insnare
insnares858083insnares
insoles73516243insoles
insouls737213insouls
inspanned1242853inspanned
inspect1138463inspect
inspects1255863inspects
inspire938253inspire
inspires1037623inspires
instal6712193insta_l
install779363install
installs858923installs
instance1049873instance
instances1148743instances
instancy1346563instancy
instar6310013insta_r
instate71616483instate
instates81615833instates
insteps936573insteps
instils7811453instils
insulant849873insulant
insulants946913insulants
insulars8137323insulars
insulins848863insulins
insults7268963insults
insurant8411413insurant
insurants947643insurants
insures73117263insures
interns73116773interns
intrant7318753intrant
intrants8312863intrants
introns73515023introns
inturns73210133inturns
inulins7311493inulins
inurns63310983in_urns
invars9310003in_vars
inwraps12105253inwraps
isbas71010403i_sba_s
island738533i_sland
islands837323i_slands
isospins1044223isospins
issuant748263issuant
japans1539823_japans
kingpins1544903kingpins
kinsman1335963kinsman_
kneepans1462733kneepans
lifespans1462463lifespans
linsang835863lins_ang
linsangs944413lins_angs
messans92710463messans
minivans1345413minivans
minyans1237263min_yans
mispens11311073mispens
misplans1238863misplans
naans55815253_n_aans
nans46139403_n__ans
napas75924353_napa_s
ninepins1045873ninepins
nipas77116673_nipa_s
nopals84914023_nopals
outspans1038223outspans
pans65855733___pans
sampans112411003sampans
sans45153363__s_ans
scans74625103__scans
spaes76029973__spaes
spams94922193__spams
span65234663__span_
spang84919733__spang
spank115919573__spank
spanks124514123__spanks
spars75431543__spars
spas67036723__spa_s
spats75031383__spats
spawns11577923__spawns
spays105520513__spays
speans85417143__speans
spins75327983__spins
swans84625013__swans
taipans9269553taipans
tampans113310983tampans
tarpans92513533tarpans
teopans939203teopans
trapans92812463trapans
trepans92311593trepans
tympans14236813tympans
unbans81912623un_bans
unmans82211993un_mans
unpens82511013un_pens
unpins82312383un_pins
unsays9399543uns_ays
unseals73212573unseals
unseams9338913unseams
unseats73012853unseats
unsnags835463unsnags
unsnaps935423unsnaps
unspeaks1443593unspeaks
unspent92610893unspent
unspun865793unspun_
wingspan1442793wingspan_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271516.61020276.4
3Display Results1511510.0602516.7
 (SQL Overall)1786911517.07625253.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.