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

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

54 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
missionized2312322(None) 
missionize21184411missionize_
missionizer22122781missionizer
missionizes22123791missionizes
missioned1248602mission__ed
missionizers23102052missionizers
fictionized2653363fictionized
fissioned1345523fission__ed
micronized2447013mi_cronized
missioner1147883mission__er
missioning1347403missioni_ng
missionizing2453193missionizing
deionized2057154__deionized
disseized2046324diss__eized
divinized2396114di_vi_nized
fictionize2454204fictionize_
fictionizes2554104fictionizes
fissioning1445124fissioni_ng
fossilized2343444fossi_lized
ionized172611294____ionized
ironized1858204_i__ronized
lionized1837024___lionized
matronized2265464m_atronized
micronize2248904mi_cronize_
micronizes2349004mi_cronizes
midsized2144734mids___ized
minimized2345204mi_ni_mized
misatoned1246694misaton__ed
miscoined1448444mi_sco_ined
miscopied1647164mi_scopi_ed
misdivided18102934misdi_vided
misjoined1945454mi_sjo_ined
mispointed1545574mispoin_ted
mispoised1446804mi_spo_ised
misprized2346604mi_s_prized
missilries1244094missilri_es
mission9312744mission____
missional1146064mission__al
missionaries1453624missionaries
missionary1553664mission_ary
missioners1245854mission_ers
missions10311904mission___s
missorted1247034miss_o_rted
missounded1443024miss_ounded
misstopped17102814missto_pped
missuited1257024miss__uited
opsonized2174474_ops_onized
pidginized2452714pidgi_nized
prussianized24122204prussianized
siliconized2352244siliconized
simonized2146524__simonized
sissified1345544sissi_fi_ed
unionized1946674__unionized
visioned1247014vi_sion__ed

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 Filter1786911488190.406440125.6
2DLD Change Limit148819549.06016425.9
3Display Results54540.0501080.0
 (SQL Overall)178691549.51618778.0
 
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.