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

169 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
intrants831286(None) 
entrants8311751entrants
intranets949261intranets
intrant7318751intrant_
entrant7318872entrant_
incants92012802in_cants
indrafts1295582indrafts
infants102210772in_fants
infracts1346622infracts
ingrafts12105802ingrafts
instants8910152instants
insurants947652insurants
integrants1146692integrants
intents72115702int_ents
interacts11312122interacts
intrados946562intrados
intranet8418442intranet
intreats8311552intreats
intrigants1145052intrigants
introits859712introits
introns73515022intron_s
intrusts837722intrusts
titrants838482titrants
alterants979103alterants
anurans73810553anuran_s
attracts1047793attracts
brants85723053__brants
contracts132212013contracts
contrasts112211043contrasts
courants10310803courants
currants1037933currants
detracts11138833detracts
distracts1249293distracts
distraints1166883distraints
enchants1347833enchants
engrafts1294703engrafts
entrails8310163entrails
entrains8312963entrains
entrance10311333entrance
entrances11310953entrances
entraps9109763entra_ps
entreats839783entreats
entrusts847113entrusts
errants7410643_errants
extracts1747623extracts
extranets1646363extranets
figurants1343973figurants
grants73722473__grants
hydrants1585793hydrants
ignorant947153ignorant_
implants1237883implants
imprints1247303imprints
inanes62519803in__anes
incant82418513in_cant_
incents92414533in_cents
incitants1196193incitants
incrusts1036253incrusts
indents83114663in_dents
indicants1247203indicants
indraft1199573indraft_
inebriants1243873inebriants
inerrant8412493inerrant_
inerts64517023iner__ts
infant92315133in_fant_
infanta10237253in_fanta
infantas11246013in_fantas
infante101910883in_fante
infantes11249633in_fantes
infarcts1345233infarcts
informants1544633informants
infract12610003infract_
ingraft1199503ingraft_
ingrains948983ingrains
ingrate8715123ingra_te
ingrates9514173ingrates
inhalants1244473inhalants
inlands838783in_lands
inruns6359513in_run_s
inspans937803inspan_s
instant7815353instant_
instructs1145793instructs
insulants946913insulants
insurant8411433insurant_
intact8314663int_act_
intakes11310943int_akes
integrands1244123integrands
integrant1049833integrant_
intendants1145253intendants
intends8239963int_ends
intent63122773int_ent_
interact10316473interact_
intercuts1148793intercuts
interests9312553interests
interknits1456203interknits
interknots1455023interknots
intermats111412453intermats
interments12716213interments
intermits111212203intermits
internals9712733internals
internes82721233internes
interns73116773intern_s
interplants13116753interplants
inthralls12216233inthralls
inthrals11258503inthra_ls
inthrones1299673inthrones
intines7921113int_ines
intonate8310923intonate
intonates9410243intonates
intones7816543int_ones
intorts7310973int_orts
intracity1448423intracity
intraday1244803intraday
intranasal1053303intranasal
intreat7416303intreat_
intrench1396593intrench
intrigant1047683intrigant_
intriguants1252823intriguants
introit7414533introit_
intromits1166213intromits
intron64215023intron__
intros64215773intr__os
intrudes937493intrudes
intrust7311493intrust_
intuits7310313int_uits
inturns73210133inturn_s
intwines1138043intwines
intwists1145593intwists
inurns63310983inur_n_s
invariants1374083invariants
invents102812053in_vents
inwraps12105253inwra_ps
iterant7317783iterant_
itinerants1052983itinerants
jurants14379213_jurants
migrants1138183migrants
ministrants1353863ministrants
mutants938583mut_ants
nitrate72017013nitra_te
nitrates82516223nitrates
octants9128733oct_ants
odorants946043odorants
ointments1166653ointments
operants1039483operants
outranks12298823outranks
penetrants1245273penetrants
pintanos10107553pint_anos
rants55935343___rants
reentrants1044663reentrants
regrants9310013regrants
retirants947323retirants
retracts101111313retracts
saturants946383saturants
sonorants947083sonorants
spirants1088283spirants
straits74916323_straits
strands83711953_strands
strunts7429543_strunts
titrant7315193titrant_
tracts85019073__tracts
traits65121983__traits
tranks104017763__tranks
tranqs155210313__tranqs
trans54933043__tran_s
truants738163__truants
tyrants1037453_tyrants
untracks1437523untracks
vagrants1246143vagrants
vibrants1345913vibrants
warrants1168503warrants

Search took 10 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621698.89016441.2
3Display Results1691690.0802112.5
 (SQL Overall)1786911699.37619058.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.