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 “intermixtures” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
intermixtures225204(None) 
intermixture2152451intermixture_
intermitters1454603intermitter_s
intermixes1948393intermix___es
immixtures2151884i___mmixtures
incertitudes1552624incerti_tudes
interculture1454304interculture_
interdictors1554454interdictor_s
interdiffuses2091604interdiffuses
intermingles1574394intermi_ngles
intermits111212204intermi_t___s
intermitted1476504intermi_t_ted
intermittences1872694intermittences
intermitter1366194intermi_t_ter
intermixed2046104intermix___ed
investitures1572594investi_tures
remixtures1943234__re_mixtures
admixtures2052195___admixtures
commixtures2452185__commixtures
contextures2054125conte___xtures
enteritides1245855enter_i_tides
enteritises1147735enter_i_tises
immixture2051905i___mmixture_
incertitude1452575incerti_tude_
incurvatures1751365incur_vatures
indentures1144865inde___ntures
ineptitudes1463085in_epti_tudes
infirmities16114505infirmi_t_ies
inheritors1345635inher_i_tor_s
inheritress1452415inher_i_t_ress
integrities1247785integri_t_ies
intensities11108915intensi_t_ies
intercepters16126405intercepter_s
interceptors16115745interceptor_s
intercompares19133205intercompares
intercourse1355025inter__course
intercourses1454595inter__courses
intercultural1563855intercultural
interdicted1546225interdict__ed
interdictions1667495interdictions
interdictive1855315interdictive_
interdictor1454745interdictor__
interdictory1853765interdictor_y
interdicts1347085interdict___s
interdiffuse1991725interdiffuse_
interdiffused21101295interdiffused
interdigitates1662435interdigitates
interferes1349985inter___feres
interfiles1349995interfi___les
interfluves1743855inter__fluves
interfuses1347685inter___fuses
interiorises1296885inter_iorises
interiorizes2155695inter_iorizes
interiors9513585inter_i__or_s
interjectors2155045interjector_s
interlinears12144585interlinear_s
interliners11138705interli_ner_s
interlines101116455interli___nes
interludes1147395inter___ludes
intermarries1454865interm_arries
intermats111412455interm_at___s
intermatted1476305interm_at_ted
intermeddlers1771545intermeddlers
intermeddles1652885interm_eddles
intermediaries1782525intermediaries
intermediates1654345intermediates
interments12716215interment___s
intermeshes1645565interm__eshes
interminable1656895interminable_
intermingle1445765intermi_ngle_
intermingled1653455intermi_ngled
intermissions1594145intermissions
intermit101213595intermi_t____
intermitotic1653115intermi_totic
intermittence1772875intermittence
intermittencies1961705intermittencies
intermittency2062325intermittency
intermittent1455325intermi_ttent
intermitting1547255intermi_tting
intermix17156875intermix_____
intermixing2146615intermix__ing
intermontane1464565intermontane_
internists10410245internist___s
interpreters1456185interpreter_s
interrupters1484315interrupter_s
interruptors1453605interruptor_s
intersexes1747915intersex___es
interstates11710205inter__states
interstices1348525inter__stices
intertextual1953725intertextu_al
interties9320345inter___t_ies
intertillages1452225intertillages
interviewees1853115intervi_ewees
interviewers1853225interviewer_s
intitules966785int___i_tules
intriguers1143335int_r_i_guers
intrigues1045365int_r_i_gu_es
intromitters1452175intromitter_s
inverities13410625inver_i_t_ies
investiture1472545investi_ture_
literatures1183655liter__atures
mixtures1735755_____mixtures
nervatures1363525_n_er_vatures
remixture1843675__re_mixture_
retextures1743005rete___xtures
strictures1246175_st_r_ictures
terminuses1244065__termi_nuses
termitaries1345695__termi_taries
termites10313695__termi_t__es
textures1597525__te___xtures

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 Filter1786911247900.373479064.3
2DLD Change Limit1247901108.73614284.6
3Display Results1101100.0761447.4
 (SQL Overall)1786911109.18519454.7
 
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.