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

141 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
insigne83767(None) 
ensign737522ensign_
ensigns836352ensigns
indigen9319332indigen
indigene10298602indigene
indign8308472indign_
inosine7314272inosi_ne
insane6314882ins_ane
inside7613452insi_de
insight1137912insight
insignia943662insignia
intine61021982inti_ne
unsigned1037552unsigned
antigen8311123antigen
antigene9410203antigene
arsine64021043arsi_ne
assign736783assign_
assigned1044633assigned
assignee944843assignee
assigner944853assigner
assigns836193assigns
beigne9148613_beigne
coigne94612193_coigne
consign1038773consign_
consigned1346323consigned
consignee1246563consignee
consigner1246633consigner
consigns1137533consigns
cosign958783cosign_
cosigned1235723cosigned
cosigner1135953cosigner
cosigns1047513cosigns
cosine83823513cosi_ne
design8408933design_
designed1136943designed
designee1087753designee
designer1036543designer
designs9328313designs
engine71114863engi_ne
ensigncy1443053ensigncy
ensile62616473ensi_le
eosine64519413eosi_ne
imagine1037883imagine
imine75821063i_mi_ne
impinge12427503impinge
inane52820343in__ane
incage93513623incag_e
incise83515333inci_se
incite83618733inci_te
incline9314643incline
indene73215373in_dene
indie63721473indi__e
indigence13247883indigence
indigenes11228993indigenes
indigens10288733indigens
indigent102911613indigent
indignly1344563indignly
indigo8388023indig_o
indigoes10276783indigoes
indigos9347823indigos
indite73520323indi_te
infight1437453infight
infringe1245083infringe
ingle64120433in__gle
inion54620183in_ion_
inions64417003in_ions
inking115119053inki_ng
inkstone1245413inkstone
innage73011573innag_e
inning73617633inni_ng
innings8329443innings
inosines8312703inosi_nes
inosite7314063inosi_te
insaner7310443ins_aner
inscape1138013inscape
inshore1038723inshore
inshrine1147483inshrine
insider849733insider
insides8512653insides
insights1245493insights
insignias1043533insignias
insipid1044513insipid
insist6314513insi_st
insisted998673insisted
insister888783insister
insists739083insists
insnare748243insnare
insole63515863ins_ole
inspan837513inspan_
inspans937803inspans
inspire938253inspire
instance1049873instance
instant7815343instant
instate71616473instate
instigate1048613instigate
insure63416603ins_ure
interne73218143interne
intimae9109743intimae
intime81014273inti_me
intines7921113inti_nes
intitle7610583intitle
intone61115433in_tone
intrigue945233intrigue
intwine1038513intwine
inveigle1243973inveigle
invite93715033invi_te
invitee103713543invitee
inwind10268413inwi_nd
iodine74618653iodi_ne
isogone8237913i_sogone
lasagne844063lasagne
lysine94210553lysi_ne
nine45842173_n_i_ne
nonsigner1045363nonsigner
online6315843onli_ne
onside7511803onsi_de
pensione1039773pensione
resign74212583resign_
resigned1038863resigned
resigner937793resigner
resigns83910963resigns
rinsible1046293rinsible
rinsing82516113rinsi_ng
rinsings9318013rinsings
rusine63916593rusi_ne
sign55523053__sign_
signa66114703__signa
signed83413753__signed
signee73617233__signee
signer74015633__signer
signet73621153__signet
signs65516323__signs
sine46560623__si_ne
singe65731133__singe
sinsyne1043303sins_yne
soigne74310033_soigne
tinstone848173tinstone
undine7817263undi_ne
unhinge11237283unhinge
unsight1137483unsight
ursine64114123ursi_ne

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.1561145455.1
2DLD Change Limit1340271417.36018210.2
3Display Results1411410.0602350.0
 (SQL Overall)1786911417.57623586.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.