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

53 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
nonexperimental2671761nonexperimental_
experimental2364124___experimental_
experimentally2863075___experimentally
nondepartmental2071355nondepartmental_
nongovernmental2181695nongovernmental_
experiential2163796___experi_ential_
experiment2147516___experiment___
experimentalism2893266___experimentalism
experimentalist26113266___experimentalist
experimented2473246___experiment_ed
experimenter2373176___experiment_er
experimenters2472446___experimenters
experimenting2562376___experimenting
experiments2255916___experiment__s
inexpediently2662486_inexpedi_ent_ly
nonelementary1862796none_le__mentary
noninstrumental17131846noninstrumental_
nonsedimentable2071406non__sedimentable
preexperiment2661526preexperiment___
temperamental1962146__temperamental_
compartmental2162487co__mpartmental_
condimental1655497con____dimental_
departmental1762767__de_partmental_
detrimental1454857__de__trimental_
detrimentals1553957__de__trimentals
excremental2253707___ex_cremental_
expediential2262747___expedi_ential_
expediently2453797___expedi_ent_ly
experientially2692707___experi_entially
experimentation2662717___experimentation
governmental1863487go___vernmental_
inexpedient2162817_inexpedi_ent___
inexperience23124267_inexperi_en__ce
inexperienced25112787_inexperi_en_ced
inexperiences24113937_inexperi_en_ces
noncriminal1584347non___crimin_al_
noncriminals1693037non___crimin_als
nonempirical1863007nonempiri___cal_
nonemployment2262837nonemployment___
nonemployments2372507nonemployment__s
nonexistential2171927nonex__istential_
nonexpendable2561787nonexp____endable
nonexpert1855437nonexper____t___
nonexperts1953107nonexper____t__s
nongovernment1982517nongovernment___
nonjudgmental2471497non__judgmental_
nonmental11410857non______mental_
nonpersonal13114437non__per_son_al_
nonresidential1562897non__residential_
nonterminal1355317non__ter_min_al_
nonterminals1453647non__ter_min_als
pedimental1556437_____pedimental_
temperamentally2481687__temperamentally

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.373479064.3
2DLD Change Limit95024538.90610669.7
3Display Results53530.0301766.7
 (SQL Overall)178691539.30919195.5
 
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.