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

77 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
issuant74826(None) 
instant7815352instant
insulant849882insulant
insurant8411432insurant
issuance1045222issuance
issuing836052issuing
pissant91012502piss_ant
askant10412713_askant
aslant6317753_aslant
asquint16208323asquint
assault747413assault
assent65119953ass_ent
assonant846803assonant
assuage835683assuage
descant104315593descant
discant103017263discant
displant11412223displant
disputant1245743disputant
disseat83816923dissea_t
dissent84018683diss_ent
dissonant1047473dissonant
dissuade1065933dissuade
distant83519953distant
eluant6315093_eluant
iguana735813i_guana
implant11311333implant
incant82418513i_ncant
infant92315133i_nfant
insane6314893ins_ane
inspan837513inspan_
inspans937803inspans
instants8910153instants
insulants946913insulants
insult62813673insu_lt
insurants947653insurants
intrant7318753intrant
island738533i_sland
issuable1046873issuable
issuably1344963issuably
issuances1144643issuances
issue559213issu__e
issued746723issu_ed
issuer646623issu_er
issuers746123issuers
issues648803issu_es
iterant7317783iterant
jessant1438443jessant
misplant12410763misplant
misseat93617243missea_t
missent94318713miss_ent
misspent1259173misspent
misstart10410043misstart
missuit9911303missu_it
osculant1046953osculant
ossuary1043943ossuary
passant9813943passant
piquant1848003piquant
pissants1097363piss_ants
puissant10105393puiss_ant
pursuant1046563pursuant
quant143624813__quant
savant9416043_savant
scant79735073__scant
secant84023293_secant
sejant133114483_sejant
shunt85226513_shu_nt
simulant1048083simulant
slant55238703__slant
sonant6621953_sonant
squat143720143_squa_t
squint154214793_squint
stunt55328173_stu_nt
suint55638183__suint
tissual745193tissua_l
tissuing935103tissuing
truant6315783_truant
visitant1147363visitant

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.423422437.4
2DLD Change Limit134027775.95322514.2
3Display Results77770.0302566.7
 (SQL Overall)178691776.40627894.3
 
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.