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

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

81 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
representatives2021189(None) 
representative19192311representative_
representations17153892representations
presentative1755343__presentative_
preventatives2152933__preventatives
representation16154123representati_on
presentations1548134__presentations
preservatives2152784__preservatives
preventative2054314__preventative_
representable17102334representa_ble_
fermentative20113895fe_r_mentative_
frequentatives29141365fre__quentatives
presentation1448995__presentati_on
preservative2053955__preservative_
preventives1945725__preven__tives
reorientates1253105reor_ientat__es
reorientations1465215reor_ientations
reprehensive20122835reprehen__sive_
represented1444115represen__t__ed
representer1353615represen__t__er
representers1452775represen__t_ers
representing1555135represen__ti_ng
represents1246755represen__t___s
augmentatives1961936__augmentatives
depersonalizes26113286deperson_alizes
depigmentations21102846depigmentations
depreciative2084086depr__eciative_
depressives1745176depres____sives
determinatives2052936determin_atives
fermentations1856276fe_r_mentations
frequentative28131766fre__quentative_
hypersensitive2583526hypersensitive_
hypersensitizes32103436hypersensitizes
implementations2162886implementations
personative1647076pe_r_son_ative_
prebendaries1752816__prebendari_es
premeditative2162916__premeditative_
preparatives1954446__pre_paratives
prerogatives1853436__pre_rogatives
presentable1546036__presenta_ble_
presentational1673216__presentational
presentees1247926__presen__t_ees
presentences1655696__present_ences
presentisms1555216__presen__tisms
presentnesses1554426__presentnesses
preservations1895546__preservations
presettles1245026__prese_t_t_les
preventive1847546__preven__tive_
recitatives1645196___re_citatives
recreative1549026recr__e__ative_
recriminative2053456recrimin_ative_
reforestations1754466refores__tations
regenerative1655306re_gene_rative_
regimentations1784856re_gimentations
regressivities1862536regressiviti_es
reorientate1153376reor_ientat__e_
reorientated1352706reor_ientat__ed
reorientating1473766reor_ientati_ng
reorientation1375596reor_ientati_on
repentances1556116rep___enta_nces
repetitive1545406rep___e_titive_
replantations1544866rep__lantations
reprehensions1853196reprehen__sions
represent11410076represen__t____
repressive1548116repres____sive_
repressurizes2462266repres__surizes
repristinates1572496repristinat__es
repristinations17193926repristinations
reprivatizes2653886repr___ivatizes
reprobative1855646repr___obative_
reproductives21113296repr__oductives
resensitizes2154406___resensitizes
resentive12410726___resen__tive_
restoratives1554156___restoratives
resuscitative1882356re_suscitative_
retrospectives2192786retros_pectives
revegetates1553936re_vege_tat__es
revegetations17114716re_vege_tations
reverberative2162136reverbe_rative_
supersensitive1962786supersensitive_
tentatives1345486_____tentatives

Search took 8 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.346516448.0
2DLD Change Limit95024817.00013574.9
3Display Results81810.0461760.9
 (SQL Overall)178691817.39224173.6
 
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.