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

111 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
intercompares1913320(None) 
intercompare18103521intercompare_
intercompared20122561intercompared
intercompany21112613intercompa_ny
intercomparing2162283intercomparing
intercomparison2171223intercomparison
intercalates14117264interc_alates
intercampus1752584intercamp__us
intercepters16126404interc_epters
intercoms1349334intercom____s
interconverts1853104interconverts
intercoolers1454454intercooler_s
intercostals1454614intercosta_ls
intercouple1564684intercoup_le_
intercourse1355014interco__urse
intercourses1454594interco_urses
interlopers1346194interlo_per_s
interlopes1249274interlo_p__es
interpolates1448574interpo_lates
interrogates1387104interro_gates
interspaces1546154inter__spaces
aftercares1544525afterc___ares
compares143816435_____compares
enterobiases14162995enter_obiases
intercalary1654735interc_alar_y
intercalate13117705interc_alate_
intercalated1596325interc_alated
interceders14136435interc_eder_s
intercedes131610435interc___edes
intercepted16157735interc_ep_ted
intercepter15127925interc_ep_ter
interceptors16115745interc_eptors
intercepts1448645interc_ep__ts
intercessors1453885intercessor_s
interchangers1972645interchangers
interchanges1894265interc_hanges
interclass1246995interc__la_ss
intercom1248685intercom_____
intercommunal1962555intercommunal
interconnects1762715interconnects
interconvert1754885interconver_t
interconverted2062475interconverted
intercooler1345835interco__oler
intercorporate18132805intercorporate
intercorrelates17162065intercorrelates
intercostal1365775intercosta__l
intercountry1753645intercountr_y
intercrater1349235interc__rater
intercropped1952775intercrop_ped
intercrops1446005intercrop___s
intercrosses1454125interc_rosses
interculture1454295interculture_
interfaces15410415inter___faces
interferes1349985inter___feres
intergrades1346785inter__grades
interiorises1296885interio_rises
interiorities1356705interiorities
interiorizes2155695interio_rizes
interiors9513575interio___r_s
interlaces12412055inter___laces
interlards1146815inter___lards
interleaves1447055inter__leaves
interlinears12144585interlinear_s
interloans1048265interlo__a_ns
interlooped1444355interloop__ed
interloops1245485interloop___s
interlope1149185interlo_p__e_
interloped1347635interlo_p__ed
interloper1247475interlo_p__er
intermale11712315inter__m_ale_
intermarries1454865inter__marries
intermarry1564155inter__m_arry
intermats111412455inter__m_a_ts
intermediaries1782525intermediaries
intermediates1654345intermediates
intermeshes1645565inter__meshes
intermixes1948395inter__m_ixes
intermixtures2252045intermixtures
intermontane1464565intermontane_
internodes1148675interno___des
interoceptors17144035interoceptors
interparish1655585inter___parish
interparty1546855inter___party
interpellates1554875interpellates
interpermeates1863465interpermeates
interphases1646155inter__phases
interpolate1369335interpo_late_
interpolated1547485interpo_lated
interposers1346265interpo_ser_s
interposes12410565inter___poses
interpret11413365inter___p_ret
interprets1249335inter___p_rets
interrelates12148075inter_relates
interrobangs1552685interro_bangs
interrogate1277615interro_gate_
interrogated1476375interro_gated
interrogatee1386215interro_gatee
interrogatees1494175interrogatees
interrogees1245655interro__gees
interrupters1484315inter_rupters
interspace1446155inter__space_
interspaced1644545inter__spaced
intersperse1354965inter__sperse
intersperses1454755inter__sperses
interstates11710205inter__states
intertillages1452225intertillages
intervales131010515inter___vales
interweaves1745685inter__weaves
interworks1746705interwo___rks
intracompany2161535intracompa_ny
overcompress2182915_overcomp_ress

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.390458182.1
2DLD Change Limit1247901118.78014213.0
3Display Results1111110.0801387.5
 (SQL Overall)1786911119.25019317.9
 
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.