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

83 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
representations1715389(None) 
representation16154121representation_
presentations1548132__presentations
representatives20211892representatives
presentation1448993__presentation_
reorientations1465213reor_ientations
representative19192313representati_ve
depigmentations21102844depigmentations
fermentations1856274fe_r_mentations
implementations2162884implementations
presentational1673214__presentational
preservations1895544__preservations
reforestations1754464refores__tations
regimentations1784854re_gimentations
reorientation1375594reor_ientation_
replantations1544864rep__lantations
reprehensions1853194reprehen__sions
representing1555134represen__ti_ng
repristinations17193924repristinations
revegetations17114714re_vege_tations
assentations1245845___assentations
cementations1659015___cementations
decrepitations1984345decre_pitations
deforestations1853965defores__tations
depigmentation20103045depigmentation_
deprecations1748565depr__e_cations
depreciations1846575depr__eciations
depredations1646735depr__e_dations
detestations1347585de_tes__tations
fermentation1756825fe_r_mentation_
forestations1546325_fores__tations
frequentations2652245fre__quentations
impersonations1863655imperson_ations
implementation2063155implementation_
impregnations1853775impre_gn_ations
necessitations16122795ne_cessitations
orientations1246915__or_ientations
perennations1447255__p_erennations
personations1448395pe_r_son_ations
pigmentations1854095__pigmentations
placentations17103635__placentations
premeditations1955015__premeditations
preselections17144445__preselections
presentative1755345__presentati_ve
preservation1776285__preservation_
preventatives2152935__preventatives
preventions1648535__preven__tions
protestations1555815__protestations
recantations1448875___recantations
recommendations22113095recommendations
reconsecrations1995105reconsecrations
recreations13412255recr__e__ations
recriminations1856725recrimin_ations
reescalations1573785re__escalations
reforestation1654575refores__tation_
refrigerations1863775refrige_rations
regenerations1447145re_gene_rations
regimentation1695435re_gimentation_
reimplantations1961905reimplantations
reinfestations1793885re_infestations
rejuvenations23122695re_juven_ations
reorientating1473765reor_ientati_ng
repetitions1378025rep___e_titions
replantation1445525rep__lantation_
reprehension1753375reprehen__sion_
representable17102335representa__ble
representers1452775represen__t_ers
represents1246755represen__t___s
repressions1348965repres____sions
repristination16204105repristination_
reprobations1647775repr___obations
reputations13410735rep____utations
reregistrations1672825re_registrations
reregulations1455715re_re_gulations
reservations1588585___reservations
restations10315845___res__tations
resuscitations1673785re_suscitations
revegetation16105305re_vege_tation_
reverberations19113585reverbe_rations
sedimentations1754415se_dimentations
segmentations1655595se__gmentations
superfetations1975065superfe_tations
superstations15208145supers__tations

Search took 6 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 Filter178691658740.656272394.8
2DLD Change Limit65874834.73613909.2
3Display Results83830.0601383.3
 (SQL Overall)178691835.45232775.3
 
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.