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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
interoperative197436(None) 
inoperative1646743in___operative
interoceptive2074453interoce_ptive
interoperable1763573interopera_ble
interpolative1865663inter_polative
interpretative1993803interpretative
interpretive1775843inter_p_retive
incorporative20124064incor_porative
integrative1547124inte___grative
intemperate1555774inte_mperat__e
interfertile1556424inter_fer_tile
interrogative17104984inter_rogative
introspective2073574int_rospe_ctive
introversive1863214int_rover_sive
nonoperative1756284_n_onoperative
preoperative1955754_pre_operative
uncooperative2083104un_cooperative
cooperative1847055___cooperative
deteriorative1762585deter_iorative
exonerative2155395___exonerative
exteroceptive2791505exteroce_ptive
imperative1748565i____mperative
intellective1754655inte_lle_ctive
intemperance1853785inte_mpera_nce
intemperately2063185inte_mperately
intenerate1048745inte__nerat__e
intenerating1346725inte__nerating
inteneration1248625inte__neration
interactive1659635inter___active
intercorporate18132805intercorporat__e
interdictive1855315inter__dictive
intergeneration1673395intergeneration
interleave1347615inter_le_a__ve
interoceanic1653875interoce_ani_c
interparticle17132625inter_par_ticle
interpellate1455415inter_pellat__e
interpellating1754535inter_pellating
interpellation1665615inter_pellation
interpermeate1754235inter_permeate
interpermeating2063075inter_permeating
interpolate1369335inter_polat__e
interpolating1657795inter_polating
interpolation1558555inter_polation
interpopulation1963595interpopulation
interpretable1753945inter_pretable
interpretation16115865interpretation
interpreting1588305inter_p_reting
interpretively2262935inter_p_retively
interrelate11188975inter_relat__e
interrelating1457295inter_relating
interrelation1358735inter_relation
interrogatives18133475inter_rogatives
interruptive1754325inter__ruptive
interservice1754075inter_ser_vice
intersperse1354965intersper___se
interspersing1654485intersper_sing
interspersion1564395intersper_sion
intersterile1254285interster__ile
interstratify1963075inter_stratify
interweave1646255inter_we_a__ve
introgressive1762795int_rogressive
introverting1654275int_rover_ting
iterative12410715i_t____erative
noncooperative21113475noncooperative
operative141110555_____operative
overoperate1676695_overoperat__e
overoperating1956725_overoperating
postoperative2063275_postoperative
recuperative1954185__recuperative
reverberative2162135rever_berative
seronegative1652695__seronegative
tolerative1346255__t__olerative
vituperative2072185vit__uperative

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 Filter178691950240.360496363.9
2DLD Change Limit95024736.11015552.2
3Display Results73730.0461587.0
 (SQL Overall)178691736.51627423.4
 
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.