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

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

37 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
interbehavioral237951interbehavioral_
interbehavior2161823interbehavior___
interbehaviors2261403interbehavior__s
nonbehavioral2171015_n_onbehavioral_
behavioral1851376_____behavioral_
intercessional1663646interce_ssional_
interjectional23195606interje_ctional_
international1357676inter__national_
internationals1454246inter__nationals
interregional1453766interre__gional_
interrogational1693906interrogational_
intersectional16146256interse_ctional_
behaviorally2361197_____behaviorally
enteroviral1452817enter___ovi_ral_
interactional1557007inter__actional_
interdivisional1971727interdivisional_
interfacial1656297inter__faci__al_
interfamilial1862747inter__familial_
interfluvial1852677inter_fluvi__al_
interglacial1554037inter_glaci__al_
interglacials1662557inter_glaci__als
interindividual208817interindividual_
interiorly1347047inter_____ior_ly
interleaving1676167interle_avi___ng
internationally1873717inter__nationally
interneuronal1362697interne__uronal_
interpersonal1564027interpe__rsonal_
interpluvial1752837inter_pluvi__al_
interracial1357077inter__raci__al_
interrelation1358737interrelatio___n
interrelations1457617interrelatio__ns
interstadial1354087inter_stadi__al_
interstadials1462537inter_stadi__als
interterminal1554307interte_rmi_nal_
intervertebral1961657interve_rtebral_
interweaving1985167interwe_avi___ng
intravital1354827int_r___avi_tal_

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 Filter178691950240.360496363.9
2DLD Change Limit95024378.73310881.0
3Display Results37370.0331121.2
 (SQL Overall)178691379.12619580.4
 
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.